create external table jms_ods.tab_warehouse_warm_config
   (
    id                       string comment 'id',
        time_frame          string comment '天数范围', 
        count_frame          int comment '票数范围', 
        pressure             decimal(10,2) comment '压力值', 
    status                   tinyint comment '状态(0未生效;1生效中;2已过期)',        
        effective_start_time     timestamp comment '有效开始时间',
        effective_end_time       timestamp comment '有效结束时间',
        delete_flag            tinyint comment '删除标识(0已删除,1未删除)',
        create_by_name         string comment '创建人名称', 
        create_by_code         string comment '创建人code', 
        create_time             timestamp comment '创建时间', 
        update_time              timestamp comment '修改时间', 
        update_by_name        string comment '修改人名称', 
        update_by_code         string comment '修改人code', 
        remark                string comment '备注(预留字段)'
   )
       comment '爆仓告警配置表'
        partitioned by (dt string comment '时间分区')
        stored as parquet
    location '/dw/hive/jms_ods.db/external/tab_warehouse_warm_config'
    tblproperties (
      'parquet.column.index.access'= 'true'
);